<%@page import="java.sql.Resule"%>
<%@page import="java.sql.Ststement" %>
<%@page import="java.sql.Connection"%>
<%@page import="java.sql.DriverManager"%>
<%@page language="java" contentType="text/html;charset=UTF-8"
   pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>查询成语数据库</title>
<style type="text/css">
h1{color:red;}
</style>
</head>
<body>
<h1>成语数据库的前10条记录</h1><%
Class.forName("com.mysql.cj.jdbc.Driver");
try(Connection cn=DriverManager.getConnection)("jdbc:mysql://localhost:3306/db","root","12qwas");
Statement stat=cn.createStatement();
ResultSet rs=stat.executeQuery("select cy as 成语 from chengyu limit 10")){
while(rs.next()){
	String cy=rs.getString("cy");
	out.println("<p>"+cy+"</p>");
}
}catch(Exception e){
	out.println("<p>"+e.getMessage()+"</p>");
}
%>
</body>
</html>